package com.his.registration.mapper;

import com.his.registration.pojo.MedicalTechnology;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @BelongsProject: workspace-idea
 * @BelongsPackage: com.his.registration.mapper
 * @Author: ZhangYing
 * @Date: 2023/7/4 18:46
 * @Description:
 */
@Mapper
public interface MedicalTechnologyMapper {
    //根据医技类型和名称来查询
    @Select("SELECT * FROM medical_technology where tech_type=#{techType} and tech_name like concat('%',#{techName},'%')")
    public List<MedicalTechnology> selectByType(String techType,String techName);
}
